SUPPORT / SAMPLES & SAS NOTES
Problem Note 62794: PROC ASTORE gives "data set ... has 0 observations and 0 variables ... was not replaced because new file is incomplete" when scoring a large model
 |  |  |  |
When you use PROC ASTORE in SAS® High-Performance Data Mining, the output table might not be generated. Messages such as these are displayed:
NOTE: The data set name has 0 observations and 0 variables.
WARNING: Data set name was not replaced because new file is incomplete.
WARNING: Data set name was not replaced because new file is incomplete.
The problem occurs when the procedure is used to score a large forest model.
There is no workaround.
Example: PROC HPFOREST was used to create a model (hpf_00000201_p_0.sasast) that is approximately 2.2GB in size. A NOTE message is displayed by PROC ASTORE to indicate that the output table (specified by the OUT= option in the SCORE statement) has 0 observations and 0 variables. A WARNING message is displayed to indicate that the output table was not replaced.
Code:
%let path1= D:\Ann\hpf_00000201_p_0.sasast;
/*try to score model in astore*/
proc astore;
score store="&path1" data=work.newtable out=WORK.RESULT;
run;
proc astore;
score store="&path1" data=work.newtable out=WORK.RESULT;
run;
Log:
NOTE: PROCEDURE ASTORE used (Total process time):
real time 1.17 seconds
cpu time 1.17 seconds
real time 1.17 seconds
cpu time 1.17 seconds
NOTE: The data set WORK.RESULT has 0 observations and 0 variables.
WARNING: Data set WORK.RESULT was not replaced because new file is incomplete.
WARNING: Data set WORK.RESULT was not replaced because new file is incomplete.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS High-Performance Data Mining | HP-UX IPF | 14.1 | 15.1 | 9.4 TS1M3 | 9.4 TS1M6 |
| Windows 7 Professional x64 | 14.1 | 15.1 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Windows 7 Ultimate 32 bit | 14.1 | 15.1 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Windows 7 Ultimate x64 | 14.1 | 15.1 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| 64-bit Enabled AIX | 14.1 | 15.1 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| 64-bit Enabled Solaris | 14.1 | 15.1 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Windows 7 Professional 32 bit | 14.1 | 15.1 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Windows 7 Home Premium x64 | 14.1 | 15.1 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Windows 7 Home Premium 32 bit | 14.1 | 15.1 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Windows 7 Enterprise x64 | 14.1 | 15.1 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Windows 7 Enterprise 32 bit | 14.1 | 15.1 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 Std | 14.1 | 15.1 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Std | 14.1 | 15.1 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 14.1 | 15.1 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 Datacenter | 14.1 | 15.1 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2008 for x64 | 14.1 | 9.4 TS1M3 | ||||
| Microsoft Windows Server 2008 R2 | 14.1 | 9.4 TS1M3 | ||||
| Microsoft Windows Server 2008 | 14.1 | 9.4 TS1M3 | ||||
| Microsoft Windows 10 | 14.1 | 15.1 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro x64 | 14.1 | 15.1 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro 32-bit | 14.1 | 15.1 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise x64 | 14.1 | 15.1 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 14.1 | 15.1 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Pro x64 | 14.1 | 15.1 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Pro 32-bit | 14.1 | 15.1 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Enterprise x64 | 14.1 | 15.1 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Enterprise 32-bit | 14.1 | 15.1 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Microsoft® Windows® for x64 | 14.1 | 15.1 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Solaris for x64 | 14.1 | 15.1 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Linux for x64 | 14.1 | 15.1 | 9.4 TS1M3 | 9.4 TS1M6 | ||